package com.itheima.mapper;

import com.itheima.pojo.Vip;
import org.apache.ibatis.annotations.Select;

public interface VipMapper {

     /**
      * 根据手机号查询会员信息
      * @param telephone
      * @return
      */
     @Select("select id, user_phone from vip where user_phone = #{telephone}")
     Vip selectByTelephone(String telephone);

     /**
      * 添加会员信息
      * @param telephone
      */
     @Select("insert into vip (user_phone) values(#{telephone})")
     void add(String telephone);
}
